Z4Soft PTab Spreadsheet

Z4Soft PTab Spreadsheet v.1.5 (TRIAL) for Palm-Size PC

Web site: www.z4soft.com
Email: email@z4soft.com

Z4Soft PTab Spreadsheet v.1.5 runs on all Palm-Size PC (devices without physical keyboard) with Windows CE 2.x. It does not run on PocketPC (devices with Windows CE 3.0).

Installation
1. Connect your PPC to your desktop PC
2. Install PTab: Run PTabSetup.exe

The on-line help is available from the Start menu when PTab is running.

How to convert Microsoft Excel (.xls) files:

Check Conversion Properties:

- If you have Windows Services 2.x: Open MS Explorer, in Mobile Devices select your PalmPC, from the menu Tools / File Conversion open the PPC File Conversion Properties dialog

Microsoft ActiveSync

Tools / Options

Rules

Conversion Settings...

select (confirm you have selected) conversion from Excel(*.xls) to PTab(*.pt) in the Desktop->Device tab:

Edit...

select (confirm you have selected) conversion from PTab(*.pt) to Excel(*.xls) in the Device->Desktop tab:

Edit...

Convert your files:

Conversion is done by dragging your files from/to your desktop computer to/from your document folder on your PPC.

Z4Soft PTab Spreadsheet

Z4Soft PTab is a spreadsheet for Palm-Size PC with the key features of common desktop spreadsheets:

Export/Import Microsoft Excel (.xls) files (using desktop filters) and Microsoft Pocket Excel (.pxl) files directly.
Import CSV (Comma Separated Values)
256 sheets x 16384 rows x 256 columns
Numeric, Text, Date/Time, Boolean values
124 built-in scientific, statistical, financial, date/time, logical, database and text functions
Multiple Undo/Redo
File: New, Open, Save, Save as, Delete, Properties
Cut, Copy, Paste, Paste Special, Clear (All, Content, Formats), Fill (Right, Down, Series) cells, Insert/Delete Rows/Columns
Set row height and column width, hide/unhide rows and columns, autofit row heights and column widths.
Insert function, Quick sum, Pointing
Format: Number format (General, Financial, Percentages, date/time, user defined), Alignment (General, Left, Center, Right, Center across selection, Top, Center, Bottom, Wrap Text), Font, Size, Color, Background Color, Bold, Italic, Underline Borders (Left, Right, Top, Bottom, Outline)
Zoom (25% - 200%) and full screen mode
Freeze Titles (row and column freezing)
Formula bar or in place editing
Show/hide: Column and row titles, Gridlines, Zero values
Sheets: New, Rename, Delete
Sort (Ascending, Descending, up to 3 keys), Go to cell, Find/Replace
Names (define and insert)
Custom lists (e.g. Monday, Thursday, Wednesday...)

What is new in PTab v.1.5 ?

Formula bar (optional)
Paste Special
Fill Series, Autofill using custom lists (e.g. January, February,...)
New worksheet functions: Columns, Countblanks, Countif, Datevalue, Daverage, Dcount, Dcounta, Dget, Dmax, Dmin, Dproduct, Dstdev, Dstdevp, Dsum, Dvar, Dvarp, Match, N, Rows, Sumif, T, Timevalue
Row: Height, Autofit, Hide, Unhide
Column: Width, Autofit, Hide, Unhide
Full Screen mode
Replace
Header row in Sort
Options: Formula bar on/off, Move selection after Enter (None, Right, Down), Custom Lists (Import from selection, Delete list)
Define and Insert Name
Direct Import/Export of Pocket Excel files (*.pxl)

Entering Data / Editing Cells

A cell can contain: number, text, date/time, Boolean value or formula. Tap on formula bar (or double-tap the cell if formula bar is off) to edit cell's value/formula. If the number or the date begins with a single quote ', it is treated as a text.

Number, example: 123.45, -1.2e55
Text
Date/Time format is taken from the PPC regional settings (menu Start/Settings/Regional Settings, tab Number, List separators combo box). You must specify a year in the date. Examples: 8/22/99 in the U.S.A. vs. 22.8.99 in Germany, 10:44, 12/30/1999 14:25:30
Boolean: true or false
Formula: Formulas begin with an equal sign =, PTab evaluates its value. Example: =A5+2, =Sum(B2:C7). It can contain:

Number, text , date/time, Boolean values
Cell references, example: A4, $B7, $C$3, Sheet1!A3, '2ndSheet'!$C$7
Cell ranges, example: A1:B4, 'Year 1999'!C5:D7
Arithmetic operators: +, -, /, *, %, ^ , example: A1*B5%, C7*100-5
Comparative operators: =, <>, <, <=, >, >=, example: if(A1>B1, A1, B1)
Text joining operators: &, example: A1 & " years"
Functions: see below.

File Menu

New - creates a new workbook.
Open - opens a workbook.

Start

Settings

Regional Settings

Number

List separators

Text Files (*.csv)

Type

Save - saves the current workbook. If you have not saved the workbook yet, Save works as Save As.
Save As - saves the current workbook with a specified name.
Delete - deletes specified file.
Properties - shows specified file's properties.
Close - closes the current workbook.

Edit Menu

Undo - undoes the last action.
Redo - redoes the last action.
Cut - cuts the selected cells to the clipboard.
Copy - copies the selected cells to the clipboard. If you paste the copied contents of the clipboard into another application, cell texts separated by tabs are pasted.
Paste - pastes the clipboard contents to the sheet. You can paste texts separated by tabs from another application.
Paste Special - pastes the clipboard contents to the sheet using special options (paste contents, paste formats, paste only the results of formulas, skip empty cells).
Clear All/Contents/Format - clears contents+format/contents/format of selected cells.
Fill Right/Down/Series - fills the selected cells by the leftmost/topmost cell contents or fill Series: linear, growth, date (date unit: day, weekday, month, year) or autofill (e.g. January, February, March...).
Delete Cells - remove the selected rows/columns.
Insert Cells - inserts the same number of rows/columns as selected.
Insert Function - inserts a function to the current cell.

Format menu

Cells - changes cell(s) numeric/date&time format (you can add your own numeric/date&time format), alignment, font and borders.
Row > Height/AutoFit/Hide/Unhide - sets row height.
Column > Width/AutoFit/Hide/Unhide - sets column width.
Zoom - change the magnification of the sheet. You can specify 25 - 200 percent.
Full Screen - full screen mode on/off.
Freeze Titles - allow row and/or column titles to stay visible as you scroll the sheet. To freeze the vertical titles, select the column to the right of where you want the split to appear. To freeze the horizontal titles, select the row below where you want the split to appear. To freeze both titles, select the cell below and to the right of where you want the split to appear.

Tools Menu

Sheets - adds/renames/deletes sheets.
Go to - selects specified cell or range.
Find - finds a cell in the current sheet containing the specified text. You can search by rows or columns, look in values or formulas, search case sensitive/insensitive.
Replace - finds and replaces a cell containing the specified text. Search options: search by rows or columns, search entire cells only, search case sensitive/insensitive.
Name > Insert/Define - defines and inserts a name in a formula.
Sort - sorts a selected range of cells: ascending or descending, case sensitive/insensitive, sorts rows or columns, exclude header row from sort.
Options - View options: enables/disables formula bar, showing of column and row titles, gridlines and zero values. General options: move after enter (none/right/down), full screen zoom. Custom lists: import from selection, delete list.
About - Z4Soft PTab spreadsheet: copyright, version and contact info.

Spreadsheet functions

Math & Trig Functions

Abs(number) Returns the absolute value of a number. Example: Abs(-3) equals 3
Acos(number) Returns the arccosine of a number. The number must be from -1 to 1. Example: Acos(-0.5) equals 2.094395
Acosh(number) Returns the inverse hyperbolic cosine of a number. The number must be greater or equal to 1. Example: Acosh(1) equals 0.04613
Asin(number) Returns the arcsine of a number. The number must be from -1 to 1. Example: Asin(-0.5) equals -0.5236
Asinh(number) Returns the inverse hyperbolic sine of a number. Example: Asinh(8) equals 2.77647
Atan(number) Returns the arctangent of a number. Example: Atan(0.5) equals 0.46365
Atan2(x,y) Returns the arctangent of the specified x and y coordinates. Example: Atan2(1, 1) equals 0.785398
Atanh(number) Returns the inverse hyperbolic tangent of a number. The number must be between -1 and 1 (excluding -1 and 1). Example: Atanh(-0.1) equals -0.10034
Ceiling(number, significance) Returns the number rounded up to the nearest multiple of the significance. Example: Ceiling(10.43, 0.1) equals 10.5
Combin(number, numberChosen) Returns the number of combinations. Number is the number of items, numberChosen is the number of items in each combination. Example: Combin(10, 2) equals 45
Cos(number) Returns the cosine of the given angle. Example: Cos(0.5) equals 0.87758
Cosh(number) Returns the hyperbolic cosine of a number. Example: Cosh(5) equals 74.20995
Degrees(number) Converts radians into degrees. Example: Degrees(Pi()/2) equals 90
Even(number) Returns the number rounded up to the nearest even integer. Example: Even(1.3) equals 2
Exp(number) Returns e raised to the power of the number. Example: Exp(Ln(2)) equals 2
Fact(number) Returns the factorial of a number. The number must be nonnegative number. Example: Fact(5) equals 120
Floor(number, significance) Rounds the number down, toward zero, to the nearest multiple of the significance. Example: Floor(3.5, 1) equals 3
Int(number) Rounds a number down to the nearest integer. Example: Int(1.7) equals 1
Ln(number) Returns the natural logarithm of a number. Example: Ln(Exp(2)) equals 2
Log(number, base) Returns the logarithm of a number to the base you specify. If the base is omitted, it is assumed to be 10. Example: Log(100, 10) equals 2
Log10(number) Returns the logarithm (base 10) of a number. Example: Log10(100) equals 2
Mod(number, divisor) Returns the remainder after the number is divided by the divisor. Example: Mod(5, 2) equals 1
Odd(number) Returns the number rounded up to the nearest odd integer. Example: Odd(2) equals 3
Pi() Returns the number 3.14159265358979, the mathematical constant PI.
Power(number, power) It raises the number to the power. You can also use the "^" operator (e.g. 4^2). Example: Power(4,2) equals 16
Product(number, number, ...) Multiplies all the numbers given as arguments and returns the product. Example: A1 contains 2, Product(A1, 5) equals 10
Radians(number) Converts degrees to radians. Example: Radians(180) equals 3.14159
Rand() Returns a random number greater than or equal to 0 and less than 1. A new number is returned every time the workbook is recalculated.
Round(number) Rounds a number to the specified number of digits. Example: Round(5.46, 1) equals 5.5
RoundDown(number, numDigits) Rounds the number down, toward zero, to the specified number of digits. Example: RoundDown(40.8, 0) equals 40
RoundUp(number, numDigits) Rounds the number up, away from zero, to the specified number of digits. Example: RoundUp(39.1, 0) equals 40
Sign(number) Returns 1 if the number is positive, 0 if the number is 0, and -1 if the number is negative. Example: Sign(-5) equals -1
Sin(number) Returns the sine of the given angle. Example: Sin(Pi()/2) equals 1
Sinh(number) Returns the hyperbolic sine of the number. Example: Sinh(3) equals 10.01787
Sqrt(number) Returns the square root. Example: Sqrt(4) equals 2
Sum(number, number, ...) Return the sum of all the numbers in the list of arguments. Example: Sum(10, 20) equals 30
SumIf(range, criteria, sumRange) It sums up the values of only those cells from the sumRange for which the corresponding cells in the range satisfy the criteria. Example: Sumif(A1:A5,">100000",B1:B5)
Tan(number) Returns the tangent of the given angle. Example: Tan(5) equals -3.38051
Tanh(number) Returns the hyperbolic tangent of the number. Example: Tanh(1) equals 0.76159
Trunc(number, numDigits) Truncates the number to an integer. The argument numDigits is the precision of the truncation. The default value for the numDigits is 0. Example: Trunc(-7.8) equals -7

Statistical Functions

Average(number, number, ...) Returns the average of the arguments. Example: Average(1, 2, 3) equals 2
Count(number, number, ...) Counts how many numbers are in the list of arguments. Example: B1 contains 5, B2 contains 3, Count(B1:B2) equals 2
CountA(number, number, ...) Counts the number of nonblank values in the list of arguments. Example: A1 contains 2, A2 is blank, CountA(A1:A2) equals 1
CountBlank(range) Counts empty cells in the specified range of cells.
CountIf(range, criteria) Counts the number of cells within the range that meets the given criteria. Example: A1 contains 6, A2 contains3, CountIf(A1:A2,">5") equals 1
Max(number, number, ...) Returns the maximum value in the list of arguments. Example: Max(1, 2, 3) equals 3
Min(number, number, ...) Returns the minimum value in the list of arguments. Example: Min(1, 2, 3) equals 1
Permut(number, numberChosen) Returns the number of permutations. Number is the number of objects, numberChosen is the number of objects in each permutation. Example: Permut(10, 2) equals 90
Stdev(number, number, ...) Estimates the standard deviation based on a sample.
StdevP(number, number, ...) Calculates the standard deviation of the entire population.
Var(number, number, ...) Estimates the variance based on a sample.
VarP(number, number, ...) Calculates the variance of the entire population.

Financial Functions

Ddb(cost, salvage, life, period, factor) Returns the depreciation of an asset for a specified period using the double-declining balance method (you can specify other method). Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation. Life is the number of periods over which the asset is being depreciated. Period is the period for which you want to calculate the depreciation. Period must use the same units as life. Factor is the rate at which the balance declines. If factor is omitted, it is assumed to be 2. All the arguments must be positive numbers. Example: Ddb(30000, 500, 3650, 10) equals 16.357
Fv(rate, nper, pmt, pv, type) Returns the future value of an investment. Rate is the interest rate per period. Nper is the total number of payment periods in an annuity. Pmt is the payment made each period. Pv is the present value. Type can be 0 or 1 (0 - payments at the end of the period, 1 - at the beginning). If type is omitted, it is assumed to be 0. Example: Fv(0.01, 12, -500) equals 6341.25
IPmt(rate, per, nper, pv, fv, type) Returns the interest payment for an investment. Per is the period for which you want to find the interest (must be 1 <= per <= nper). For more information see Pmt. Example: Ipmt(0.01, 1, 24, 5000) equals -50
Irr(values, guess) Returns the internal rate of return. Values is a reference to cells that contain the numbers for which you want to calculate the internal rate of return. Guess is your guess of the result. If guess is omitted, it is assumed to be 0.1. Example: A1:A6 contain the following values: $-100,000, $10,000, $16,000, $20,000, $22,000 and $24,000 Irr(A1:A6) equals -2.43%.
Nper(rate, pmt, pv, fv, type) Returns the number of periods for an investment. For more information see Pmt. Example: Nper(0.01, -100, -1000, 20000) equals 101
Npv(rate, value1, value2...) Returns the net present value of an investment. Rate is the rate of discount over the length of one period. Value1, value2, are arguments representing the payments (negative values) and income (positive values). Example: Npv(10%, -10000, 4000, 5000, 6000) equals 2069.53
Pmt(rate, nper, pv, fv, type) Returns the periodical payment for an annuity. Rate is the interest rate per period, nper is the number of payment periods in an annuity, pv is the present value, fv is the future value, type see Fv. Example: Pmt(0.01, 10, 10000) equals -1055.82
PPmt(rate, per, nper, pv, fv, type) Returns the payment on the principa for a given period of an investment. For more information see Pmt. Example: Ppmt(0.01, 1, 36, 1000) equals -23.21
Pv(rate, nper, pmt, fv, type) Returns the present value of an investment. For more information see Pmt. Example: Pv(0.01, 5*12, 1000, 0) equals -44955.04
Rate(nper, pmt, pv, fv, type, guess) Returns the interest rate per period of an annuity. For more information see Pmt. Guess is your guess for what the rate will be. Example: Rate(36, -300, 10000, 0) equals 0.42%
Sln(cost, salvage, life) Returns the straight-line depreciation of an asset for one period. Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation. Life is the number of periods. Example: Sln(40000, 5000, 8) equals 4375.
Syd(cost, salvage, life, period) Returns the sum-of-years' digits depreciation of an asset for a specified period. Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation. Life is the number of periods. Period is the period. Example: Syd(40000, 5000, 8, 8) equals 972.22.

Date & Time Functions

Date(year, month, day)Returns a particular date. Example: Year(Date(1999, 1, 1)) equals 1999
DateValue(dateText)Converts a date in the form of text to a serial number. Example: DateValue("1/1/99") equals 36161
Day(date) Returns the day of a date. Example: Day(1/1/99) equals 1
Hour(time) Returns the hour of a time. Example: Hour(2:45) equals 2
Minute(time) Returns the minutes of a time. Example: Minute(2:45) equals 45
Month(date) Returns the month of a date. Example: Month(1/1/99) equals 1
Now() Returns the current date and time.
Second(time) Returns the seconds of a time. Example: Second(Time(1, 45, 20)) equals 20
Time(hour, min, sec) Returns a particalar time. Time(1,45,0) equals 1:45
TimeValue(timeText) Converts a time in the form of text to a serial number. TimeValue("1:45") equals 0.072917
Today() Returns the current date.
Weekday(date, type) Returns the day of the week corresponding to a date. If type = 1 or omitted returns: 1 (Sunday) through 7 (Saturday). Example: Weekday(Date(1999,8,15)) equals 1
Year(date) Returns the year of a date. Example: Year(Date(1999, 1, 1)) equals 1999

Logical Functions

And(logical1, logical2, ...) Returns TRUE if all its arguments are TRUE, otherwise returns FALSE. Example: And(FALSE, TRUE) equals FALSE
If(condition, trueValue, falseValue) Returns trueValue if condition evaluates to TRUE or falseValue if condition evaluates to FALSE. Example: If(A1>A2, "OK", "Cancel")
Not(logical) Reverses logical value. Example: Not(TRUE) equals FALSE
Or(logical1, logical2, ...) Returns TRUE if any argument is TRUE, otherwise return FALSE. Example: Or(FALSE, TRUE) equals TRUE

Text Functions

Char(number) Returns the character specified by a number. Example: Char(66) equals B
Code(text) Returns a numeric code for the first character in a text string. Example: Code("ABC") equals 65
Exact(text1, text2) Returns TRUE if two text strings are identical (case sensitive). Example: Exact("palm", "PALM") equals FALSE
Find(findText, withinText, start) Finds string (findText) within another text string (withinText), and returns its starting position. Example: Find("A", "CBA", 1) equals 3
Left(text, num_chars) Returns the leftmost characters from a text string. Example: Left("Palm PC", 2) equals "Pa"
Len(text) Returns the number of characters in a text string. Example: Len("Palm PC") equals 7
Lower(text) Converts text to lowercase. Example: Lower("Palm PC") equals "palm pc"
Mid(text, start, count) Returns a specific number of characters from a text string, starting at the position start. Example: Mid("Palm PC", 3, 2) equals "lm"
Proper(text) Capitalizes the first letter of all words. Converts all the other letters to lowercase. Example: Proper("this CHAPTER") equals "This Chapter"
Replace(oldText, start, count, newText) Replaces part of a text string oldText, based on the number of characters you specify (start, count), with a newText. Example: Replace("Palm PC", 5, 1, "-Size") equals "Palm_SizePC"
Rept(text, nTimes) Repeats text the given number of times. Example: Rept("-", 5) equals "-----"
Right(text, num_chars) Returns the rightmost characters from a text string. Example: Right("Palm PC", 2) equals "PC"
Substitute(text, oldText, newText, n) Substitutes newText for oldText in a text string. N specifies which occurrence of the oldText you want to replace. Example: Substitute("1/1/1999", "1", "2", 2) equals "1/2/1999"
T(value) Returns the text referred to by value. Example: A1 contains "AAA" then T(A1) equals "AAA"
Upper(text) Converts text to uppercase. Example: Upper("Palm PC") equals PALM PC
Value(text) Converts a text that represents a number to the number. Example: Value("1000") equals 1000

Information & Lookup Functions

Columns(range) Returns the number of columns in an array or reference. Example: Columns(A1:D1) equals 4
HLookup(lookupValue, data, row) Searches for a value in the top row of a data table and then returns a value in the same column from a row you specify. LookupValue is the value to be found in the first row of the data table. Data is the table of data. Row is the row number in the data table from which the matching value is returned.
IsBlank(value) Returns TRUE if the value is blank.
IsErr(value) Returns TRUE if the value is any error value except !!NA.
IsError(value) Returns TRUE if the value is any error value.
IsLogical(value) Returns TRUE if the value is a logical value.
IsNA(value) Returns TRUE if the value is error value !!NA.
IsNonText(value) Returns TRUE if the value is any value that is not text.
IsNumber(value) Returns TRUE if the value is a number.
IsRef(value) Returns TRUE if the value refers to a reference.
IsText(value) Returns TRUE if the value is text.
Match(lookupValue, lookupRange, matchType) Returns the position of an item in a range that matches a specified value in a specified order. LookupValue is the value you want to match in the range.
N(value) Returns a value converted to a number.
NA() Returns the error value !!NA (no value is available).
Rows(range) Returns the number of rows in a reference or array. Example: Rows(A1:A5) equals 5
VLookup(lookupValue, data, column) Searches for a value in the leftmost column of a data table, and then returns a value in the same row from a column you specify. LookupValue is the value to be found in the first column of the data table. Data is the table of data. Column is the column number in the data table from which the matching value is returned.

Database Functions

Daverage(database, field, criteria) Averages the values in the specified database column matching the conditions.
Dcount(database, field, criteria) Counts the cells containing numbers in the specified database column matching the conditions.
Dcounta(database, field, criteria) Counts nonblank cells in the specified database column matching the conditions.
Dget(database, field, criteria) Extracts a single value from the specified database column matching the conditions.
Dmax(database, field, criteria) Returns the largest number in the specified database column matching the conditions.
Dmin(database, field, criteria) Returns the smallest number in the specified database column matching the conditions.
Dproduct(database, field, criteria) Multiplies the values in the specified database column matching the conditions.
Dstdev(database, field, criteria) Estimates the standard deviation based on a sample, using the numbers i in the specified database column matching the conditions.
Dstdevp(database, field, criteria) Calculates the standard deviation of a population based on the entire population, using the numbers in the specified database column matching the conditions.
Dsum(database, field, criteria) Adds the numbers in the specified database column matching the conditions.
Dvar(database, field, criteria) Estimates variance based on a sample, using the numbers in the specified database column matching the conditions.
Dvarp(database, field, criteria) Calculates the variance of a population based on the entire population, using the numbers in the specified database column matching the conditions.